package dict

import "gitee.com/alex_li/amazon-rpt/internal/db"

func init() {
	_addRptColumn(SearchTerm, AdProduct, db.Column{
		Field: "campaignName",
		Type:  db.String,
	},
		db.Column{
			Field: "campaignId",
			Type:  db.Int64,
		},
		db.Column{
			Field: "searchTerm",
			Type:  db.String,
		},
		db.Column{
			Field: "adGroupName",
			Type:  db.String,
		},
		db.Column{
			Field: "adGroupId",
			Type:  db.Int64,
		},
		db.Column{
			Field: "matchType",
			Type:  db.String,
		},
		db.Column{
			Field: "impressions",
			Type:  db.Int64,
		},
		db.Column{
			Field: "clicks",
			Type:  db.Int,
		},
		db.Column{
			Field: "costPerClick",
			Type:  db.Float64,
		},
		db.Column{
			Field: "clickThroughRate",
			Type:  db.Float64,
		},
		db.Column{
			Field: "cost",
			Type:  db.Float64,
		},
		db.Column{
			Field: "sales1d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "sales7d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "sales14d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "sales30d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "portfolioId",
			Type:  db.Int64,
		},
		db.Column{
			Field: "targeting",
			Type:  db.String,
		},
		db.Column{
			Field: "acosClicks7d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "roasClicks7d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "purchases1d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "unitsSoldClicks1d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "unitsSoldSameSku1d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "salesOtherSku7d",
			Type:  db.Float64,
		},
		db.Column{
			Field: "attributedSalesSameSku1d",
			Type:  db.Float64,
		},
	)

	_addRptColumn(SearchTerm, AdBrand, db.Column{
		Field: "campaignName",
		Type:  db.String,
	},
		db.Column{
			Field: "campaignId",
			Type:  db.Int64,
		},
		db.Column{
			Field: "searchTerm",
			Type:  db.String,
		},
		db.Column{
			Field: "adGroupName",
			Type:  db.String,
		},
		db.Column{
			Field: "adGroupId",
			Type:  db.Int64,
		},
		db.Column{
			Field: "matchType",
			Type:  db.String,
		},
		db.Column{
			Field: "impressions",
			Type:  db.Int64,
		},
		db.Column{
			Field: "cost",
			Type:  db.Float64,
		},
	)
}
